<!DOCTYPE html>
<html lang="zh-cn">
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <meta name="description" content="">
  <meta name="author" content="">
  <link rel="icon" href="../../favicon.ico">

  <title>Off Canvas Template for Bootstrap</title>

  <!-- Bootstrap core CSS -->
  <link href="../home/View/assets/css/bootstrap.min.css" rel="stylesheet">

  <!-- Custom styles for this template -->
  <link href="../home/View/assets/css/offcanvas.css" rel="stylesheet">
  <link href="../home/View/assets/css/style.css" rel="stylesheet">
  <!-- Just for debugging purposes. Don't actually copy these 2 lines! -->
    <!--[if lt IE 9]>
    <script src="assets/js/ie8-responsive-file-warning.js"></script><![endif]-->
    <script src="../home/View/assets/js/ie-emulation-modes-warning.js"></script>

    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
    <script src="http://cdn.bootcss.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="http://cdn.bootcss.com/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->
  </head>
  <body>
    <nav class="navbar navbar-fixed-top navbar-inverse">
      <div class="container-fluid">
        <!-- Brand and toggle get grouped for better mobile display -->
        <div class="navbar-header">
          <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>
        </div>
        <!-- Collect the nav links, forms, and other content for toggling -->
        <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
          <ul class="nav navbar-nav">
            <?php
            // require_once('system/dbConn.php');
            // connect();
            // $sql="select * from videotype";
            // $rs=mysql_query($sql)or die('查询 1 失败！'.mysql_error());
            // echo date('Y-m-d H:i',time());
            ?>
            <ul class="nav navbar-nav">
              <li><a href="index.php">首页</a></li>
              <?php
               foreach ($data['vv'] as $row)
              {
                ?>
                <li><a href="list.php?tid=<?php
                  echo $row["tid"];
                  ?>
                  "><?php
                  echo $row["typename"];
                  ?>
                </a></li>
                <?php
              }
              ?>
            </ul>   
          </ul>
          <form class="navbar-form navbar-left" role="search" action="search.php">
            <div class="form-group">
              <input type="text" class="form-control" name="videoname" placeholder="Search">
            </div>
            <button type="submit" class="btn btn-default">搜索</button>
          </form>
          <ul class="nav navbar-nav navbar-right">
            <li class="active"><a href="">欢迎<?php
              session_start();
              if(isset($_SESSION["uname"]))
                echo " ".$_SESSION["uname"]." ";
              else{
                echo "您";
              }
              ?>访问本网站</a>
            </li>
            <?php
        //登录成功才显示
            if(isset($_SESSION["uname"]))
            {
              ?>
              <li><a href="logout.php">注销</a></li>
              <li class="dropdown">
                <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button"
                aria-haspopup="true" aria-expanded="false">个人中心 <span class="caret"></span></a>
                <ul class="dropdown-menu">
                  <li><a href="#" data-toggle="modal" data-target="#changePassword">修改个人密
                    码</a></li>
                    <li><a href="#" data-toggle="modal" data-target="#changeInfor">修改个人信息
                    </a></li>
                    <li><a href="commentList.php" >我的评价</a></li>
                  </ul>
                </li>
                <?php
              }else{
                ?>
                <li><a href="#" data-toggle="modal" data-target="#login">登录</a></li>
                <li><a href="#" data-toggle="modal" data-target="#reg">注册</a></li>
                <?php
              }
              ?>  
            </ul>
          </div><!-- /.navbar-collapse -->
        </div><!-- /.container-fluid -->
      </nav>


      <!-- /.navbar -->
      <!-- /注册模态框 -->
      <div class="modal fade" id="reg" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog" role="document">
          <div class="modal-content">
            <div class="modal-header">
              <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
              <h4 class="modal-title" id="myModalLabel">请填写用户注册信息</h4>
            </div>

            <div class="modal-body">
             <form method=post action="doUserReg.php" enctype="multipart/form-data"  class="form-horizontal">
              <div class="form-group">
                <label for="exampleInputUserName" class="col-md-2 control-label">姓名</label>
                <div class="col-md-10">
                  <input type="text" name="uname" class="form-control" id="exampleInputUname" placeholder="姓名" required>
                </div>
              </div>

              <div class="form-group">
                <label for="exampleInputPassword" class="col-md-2 control-label">密码</label>
                <div class="col-md-10">
                  <input type="password" name="password" class="form-control" id="exampleInputPassword" placeholder="密码" required>
                </div>
              </div>

              <div class="form-group">
                <label class="col-md-2 control-label">性别</label>
                <div class="col-md-10">
                  <label class="radio-inline">
                    <input type="radio" name="gender"  value=0 checked> 男
                  </label>
                  <label class="radio-inline">
                    <input type="radio" name="gender" value=1> 女
                  </label>
                </div>
              </div>

              <div class="form-group">
                <label for="exampleInputBirth" class="col-md-2 control-label">生日</label>
                <div class="col-md-10">
                  <input type="date" name="birthdate" class="form-control" id="exampleInputBirth" placeholder="生日" required>
                </div>
              </div>

              <div class="form-group">
                <label  class="col-md-2 control-label">爱好</label>
                <div class="col-md-10">
                 <label class="checkbox-inline">
                  <input type="checkbox"  name="hobby[]" value="旅游"> 旅游
                </label>
                <label class="checkbox-inline">
                  <input type="checkbox" name="hobby[]" value="登山"> 登山
                </label>
                <label class="checkbox-inline">
                  <input type="checkbox" name="hobby[]"  value="健身"> 健身
                </label>
                <label class="checkbox-inline">
                  <input type="checkbox" name="hobby[]"  value="上网"> 上网
                </label>
                <label class="checkbox-inline">
                  <input type="checkbox"  name="hobby[]" value="游泳"> 游泳
                </label>
              </div>
            </div>

            <div class="form-group">
              <label  class="col-md-2 control-label">学历</label>
              <div class="col-md-10">
                <select  class="form-control" name="degree">
                  <option value="0">请选择</option>
                  <option value="1">高中</option>   
                  <option value="2">大学</option>
                  <option value="3">研究生</option>  
                  <option value="4">博士生</option>
                </select>
              </div>
            </div>

            <div class="form-group">
              <label for="exampleInputTextarea1" class="col-md-2 control-label">自我介绍</label>
              <div class="col-md-10">
                <textarea class="form-control" rows="3"  id="exampleInputTextarea1" placeholder="自我简介：" name="intro"></textarea>
              </div>
            </div>

            <div class="form-group">
              <label for="exampleInputFile" class="col-md-2 control-label">头像</label>
              <div class="col-md-10">
                <input type="file"  name="pic" id="exampleInputFile" required>
              </div>
            </div>

            <div class="form-group">
              <div class="col-sm-offset-2 col-sm-10">
                <input type="submit" class="btn btn-default" value="提交">
                <input type="reset" class="btn btn-default" value="重置">
              </div>
            </div>

          </form>
          <?php
          if(isset($_GET["msg1"])){
            echo'<h1 style="color:red;">'.$_GET["msg1"]."</h1>";
          }
          ?>

          <?php
          if(isset($_GET["msg2"])){
            echo '<h1 style="color:red;">'.$_GET["msg2"]."</h1>";
          }
          ?> 
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-default" onclick="location.replace('index.php')" data-dismiss="modal">关闭</button>
        </div>
      </div>
    </div>
  </div>  
  <!-- /注册模态框结束 -->
  <!-- /登录模态框开始 -->
  <div class="modal fade" id="login" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
    <div class="modal-dialog" role="document">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
          <h4 class="modal-title" id="myModalLabel">请填写普通用户登录信息</h4>
        </div>
        <div class="modal-body">

          <form  name="fm" method="post" action="doLogin.php" onsubmit="return check()" class="form-horizontal">
            <?php
          //如果是show.php页面传来的登录链接，需要带着vid参数，以便登陆成功后直接返回视频内容页
            ?>
            <input type="hidden" name="uid" id="uid" >
            <div class="form-group">
              <label for="exampleInputUname" class="col-md-2 control-label">用户名</label>
              <div class="col-md-4">
                <input type="text" name="uname" class="form-control" id="exampleInputUname1" placeholder="姓名" required>
              </div>
              <div class="col-md-6">
              </div>
            </div>

            <div class="form-group">
              <label for="exampleInputPassword" class="col-md-2 control-label">密码</label>
              <div class="col-md-4">
                <input type="password" name="password" class="form-control" id="exampleInputPassword" placeholder="密码" required>
              </div>
              <div class="col-md-6">

              </div>
            </div>

            <div class="form-group">
              <div class="col-sm-offset-2 col-sm-10">
                <input type="submit" class="btn btn-default" value="登录">
                <input type="reset" class="btn btn-default" value="重置">
              </div>
            </div>
            <?php
            if(isset($_GET["msg"])){
              echo'<h1 style="color:red;">'.$_GET["msg"]."</h1>";
            }
            ?>

            <?php
            if(isset($_GET["msg9"])){
              echo'<h1 style="color:red;">'.$_GET["msg9"]."</h1>";
            }
            ?>


          </form>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-default" onclick="location.replace('index.php')" data-dismiss="modal">关闭</button>
        </div>
      </div>
    </div>
  </div>  
  <!-- /登录模态框结束 -->
  <!-- /修改密码模态框开始 -->
  <div class="modal fade" id="changePassword" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
    <div class="modal-dialog" role="document">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
          <h4 class="modal-title" id="myModalLabel">修改个人密码</h4>
        </div>
        <div class="modal-body">
          <form  name="uname" method="post" action="doChangePassword.php" onsubmit="return check()" class="form-horizontal">


            <div class="form-group">
              <label for="exampleInputPassword1" class="col-md-4 control-label">原密码</label>
              <div class="col-md-4">
                <input type="password" name="password0" class="form-control" id="exampleInputPassword1" placeholder="原密码" required>
              </div>
              <div class="col-md-4">

              </div>
            </div>


            <div class="form-group">
              <label for="exampleInputPassword1" class="col-md-4 control-label">新密码</label>
              <div class="col-md-4">
                <input type="password" name="password1" class="form-control" id="exampleInputPassword1" placeholder="新密码" required>
              </div>
              <div class="col-md-4">

              </div>
            </div>


            <div class="form-group">
              <label for="exampleInputPassword1" class="col-md-4 control-label">确认新密码</label>
              <div class="col-md-4">
                <input type="password" name="password2" class="form-control" id="exampleInputPassword1" placeholder="确认新密码" required>
              </div>
              <div class="col-md-4">

              </div>
            </div>



            <div class="form-group">
              <div class="col-sm-offset-2 col-sm-10">
                <input type="submit" class="btn btn-default" value="修改">
                <input type="reset" class="btn btn-default" value="重置">
              </div>
            </div>


            <?php
            if(isset($_GET["msg3"])){
              echo'<h1 style="color:red;">'.$_GET["msg3"]."</h1>";
            }
            ?>
            <?php
            if(isset($_GET["msg4"])){
              echo'<h1 style="color:red;">'.$_GET["msg4"]."</h1>";
            }
            ?>
            <?php
            if(isset($_GET["msg5"])){
              echo'<h1 style="color:red;">'.$_GET["msg5"]."</h1>";
            }
            ?>

          </form>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-default" onclick="location.replace('index.php')" data-dismiss="modal">关闭</button>   
        </div>
      </div>
    </div>
  </div>  
  <!-- /修改密码模态框结束 -->
  <!-- /修改个人信息模态框开始 -->
  <?php
  $uname=$_SESSION["uname"];
  $sql = "select * from user where uname='$uname'"; 
  $result = mysql_query($sql) or die('查询2失败！'.mysql_error());   
  $row = mysql_fetch_assoc($result);
  $uid=$row['uid'];
  $gender = $row['gender'];
  $birthdate = $row['birthdate'];
  $hobby = $row['hobby'];
  $degree = $row['degree'];
  $intro = $row['intro'];
  $pic = "../images/".$row['pic'];      
  ?>
  <div class="modal fade" id="changeInfor" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
    <div class="modal-dialog" role="document">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
          <h4 class="modal-title" id="myModalLabel">请修改您的注册信息</h4>
        </div>
        <div class="modal-body">

          <form method="post"  class="form-horizontal" action="doChangeInfor.php"  enctype="multipart/form-data">
            <input type="hidden" name="uid" value=<?php  echo $uid;  ?>>  

            <div class="form-group">
              <label for="uname" class="col-md-2 control-label">用户名</label>
              <div class="col-md-10">
               <input type="text" class="form-control" id="uname" readonly="readonly" name="uname" value=<?php  echo $uname;  ?>>
             </div>
           </div>

           <div class="form-group">
            <label  class="col-md-2 control-label">性别</label>
            <div class="col-md-10">
              <label class="radio-inline">
               <input type="radio"  name="gender" value="0" <?php  if(!$gender) echo 'checked';  ?>>男</label>
               <label class="radio-inline">
                 <input type="radio"  name="gender" value="1" <?php  if($gender) echo 'checked';  ?>>女</label>
               </div>
             </div>

             <div class="form-group">
              <label  class="col-md-2 control-label">生日</label>
              <div class="col-md-10">
                <input type="date" name="birthdate" class="form-control"  value=<?php  echo $birthdate;  ?>>
              </div>
            </div>

            <div class="form-group">
              <label  class="col-md-2 control-label">爱好</label>
              <div class="col-md-10">
               <label class="checkbox-inline">
                 <input type="checkbox" name="hobby[]" value="旅游" <?php  if(strstr($hobby,'旅游')) echo 'checked';  ?>>旅游
               </label>
               <label class="checkbox-inline">
                 <input type="checkbox" name="hobby[]" value="登山" <?php  if(strstr($hobby,'登山')) echo 'checked';  ?>>登山
               </label>
               <label class="checkbox-inline">
                <input type="checkbox" name="hobby[]" value="健身" <?php  if(strstr($hobby,'健身')) echo 'checked';  ?>>健身
              </label>
              <label class="checkbox-inline">
                <input type="checkbox" name="hobby[]" value="上网" <?php  if(strstr($hobby,'上网')) echo 'checked';  ?>>上网
              </label>
              <label class="checkbox-inline">
                <input type="checkbox" name="hobby[]" value="游泳" <?php  if(strstr($hobby,'游泳')) echo 'checked';  ?>>游泳
              </label>
            </div>
          </div>
          <div class="form-group">
            <label  class="col-md-2 control-label">学历</label>
            <div class="col-md-10">    
             <select name="degree">
              <option value="0">---请选择---</option>
              <option value="1" <?php  if($degree=='1') echo 'selected';  ?>>高中</option>
              <option value="2" <?php  if($degree=='2') echo 'selected';  ?>>大学</option>
              <option value="3" <?php  if($degree=='3') echo 'selected';  ?>>研究生</option>
              <option value="4" <?php  if($degree=='4') echo 'selected';  ?>>博士生</option>
            </select>
          </div>
        </div>
        <div class="form-group">
          <label  class="col-md-2 control-label">自我介绍</label>
          <div class="col-md-10">    
            <textarea name="intro" class="form-control" cols="40" rows="5"><?php  echo $intro;  ?></textarea>
          </div>
        </div>
        <div class="form-group">
          <label  class="col-md-2 control-label">头像</label>
          <div class="col-md-10">    
           <input type="file" name="pic">
           原头像：<img src="images/<?php
           echo $row["pic"];
           ?>" width="80px" height="80px" class="img-circle">
         </div>
       </div>
       <div class="form-group">
        <div class="col-sm-offset-2 col-sm-10">
          <input type="submit"  class="btn btn-default" value="更新">
        </div>
      </div>
    </form>
    <?php
    if(isset($_GET["msg7"])){
      echo'<h1 style="color:red;">'.$_GET["msg7"]."</h1>";
    }
    ?>

    <?php
    if(isset($_GET["msg8"])){
      echo '<h1 style="color:red;">'.$_GET["msg8"]."</h1>";
    }
    ?> 
  </div>
  <div class="modal-footer">
    <button type="button" class="btn btn-default" onclick="location.replace('index.php')" data-dismiss="modal">关闭</button>
  </div>
</div>
</div>
</div>  
<!-- /修改个人信息模态框结束 -->




<div class="container">
  <!--幻灯片开始-->
  <div id="carousel-example-generic" class="carousel slide" data-ride="carousel">
    <!-- Indicators -->
    <ol class="carousel-indicators">
      <li data-target="#carousel-example-generic" data-slide-to="0" class="active"></li>
      <li data-target="#carousel-example-generic" data-slide-to="1"></li>
      <li data-target="#carousel-example-generic" data-slide-to="2"></li>
    </ol>

    <!-- Wrapper for slides -->
    <div class="carousel-inner">
      <div class="item active">
        <img src="assets/images/img4.jpg" class="img-responsive" alt="Apple iPhone 5S">
        <div class="carousel-caption">
          <h3>Apple iPhone 5S</h3>
        </div>
      </div>
      <div class="item">
        <img src="assets/images/img2.jpg" class="img-responsive" alt="Samsung Galaxy Note 3">
        <div class="carousel-caption">
          <h3>Samsung Galaxy Note 3</h3>
        </div>
      </div>
      <div class="item">
        <img src="assets/images/img3.jpg" class="img-responsive" alt="Apple iPhone 5S">
        <div class="carousel-caption">
          <h3>Sony Xperia Z1</h3>
        </div>
      </div>
    </div>

    <!-- Controls -->
    <a class="left carousel-control" href="#carousel-example-generic" data-slide="prev">
      <span class="glyphicon glyphicon-chevron-left"></span>
    </a>
    <a class="right carousel-control" href="#carousel-example-generic" data-slide="next">
      <span class="glyphicon glyphicon-chevron-right"></span>
    </a>
  </div>
  <!--幻灯片结束-->


  <?php
  connect();
//查询首页电影专栏的六个视频
  $sql1="select * from videotype where typename='电影'";
  $result1 = mysql_query($sql1) or die('查询失败！'.mysql_error());
  $row1=mysql_fetch_assoc($result1);
  $tid1=$row1["tid"];
//根据查的的视频 id 查询电影栏目的六条记录
  $sql11="select * from vv where tid='$tid1' limit 6";
  $result11 = mysql_query($sql11) or die('查询失败！'.mysql_error());
//查询首页电视剧专栏的六个视频
  $sql2="select * from videotype where typename='电视剧'";
  $result2 = mysql_query($sql2) or die('查询失败！'.mysql_error());
  
  $row2=mysql_fetch_assoc($result2);
  $tid2=$row2["tid"];
//根据查的的视频 id 查询电视剧栏目的六条记录
  $sql22="select * from vv where tid='$tid2' limit 6";
  $result22 = mysql_query($sql22) or die('查询失败！'.mysql_error());
//查询首页动画片专栏的六个视频
  $sql3="select * from videotype where typename='动画片'";
  $result3 = mysql_query($sql3) or die('查询失败！'.mysql_error());
  $row3=mysql_fetch_assoc($result3);
  $tid3=$row3["tid"];
//根据查的的视频 id 查询动画片栏目的六条记录
  $sql33="select * from vv where tid='$tid3' limit 6";
  $result33 = mysql_query($sql33) or die('查询失败！'.mysql_error());
//查询首页原创专栏的六个视频
  $sql4="select * from videotype where typename='原创'";
  $result4 = mysql_query($sql4) or die('查询失败！'.mysql_error());
  $row4=mysql_fetch_assoc($result4);
  $tid4=$row4["tid"];
//根据查的的视频 id 查询原创栏目的六条记录
  $sql44="select * from vv where tid='$tid4' limit 6";
  $result44 = mysql_query($sql44) or die('查询失败！'.mysql_error());
//查询首页显示的点击排行 4 个视频和下载排行的 4 个视频
  $sql5="select * from vv order by hittimes desc limit 2";
  $sql6="select * from vv order by downtimes desc limit 4";
  $result5 = mysql_query($sql5) or die('查询失败！'.mysql_error());
  $result6 = mysql_query($sql6) or die('查询失败！'.mysql_error());
  ?>



  <div class="row row-offcanvas row-offcanvas-right">
    <div class="col-xs-12 col-sm-9">
      <div class="row text-center">
        <div class="col-xs-12 col-lg-12 mlist">
          <h2>电影</h2>
          <ul class="list-inline row text-center">
           <?php
           while($row1=mysql_fetch_assoc($result11))
           {
            ?>
            <li class="col-xs-4 col-sm-3 col-lg-2">
              <img src="./images/<?php
              echo $row1["pic"];
              ?>" class="responsive img-thumbnail"/>
              <p><a href="show.php?id=<?php
                echo $row1["id"];
                ?>"><?php
                echo $row1["videoname"];
                ?></a>
              </p>
            </li>
            <?php
          }
          ?>
        </ul>
        <p><a class="btn btn-default" href="list.php?tid=<?php
          echo $tid1;?>" role="button">更多 &raquo;</a></p>
        </div>
        <!--/.col-xs-6.col-lg-4-->
      </div>
      <!--/row-->
      <div class="row text-center">
        <div class="col-xs-12 col-lg-12 mlist">
          <h2>电视剧</h2>
          <ul class="list-inline row text-center">
            <?php
            while($row2=mysql_fetch_assoc($result22))
            {
              ?>
              <li class="col-xs-4 col-sm-3 col-lg-2">
                <img src="./images/<?php
                echo $row2["pic"];
                ?>" class="responsive img-thumbnail"/>
                <p><a href="show.php?id=<?php
                  echo $row2["id"];
                  ?>"><?php
                  echo $row2["videoname"];
                  ?></a>
                </p>
              </li>
              <?php
            }
            ?>
          </ul>
          <p><a class="btn btn-default" href="list.php?tid=<?php
            echo $tid1;
            ?>" role="button">更多 &raquo;</a></p>
          </div>
        </div>
      </div>

      <!-- 点击排行 -->
      <div class="col-xs-6 col-sm-3 sidebar-offcanvas">
       <div class="list-group text-center" id="sidebar">
        <h2 style="color:white;" >点击排行</h2>
        <ul class="list-inline row text-center">
          <?php
          while($row5=mysql_fetch_assoc($result5))
          {
            ?>
            <li class="col-xs-12 col-lg-6">
              <img src="./images/<?php
              echo $row5["pic"];
              ?>" class="responsive img-thumbnail" />
              
              <p><a href="show.php?vid=<?php
                 echo $row5["vid"];
                ?>"><?php
//显示视频名称中的前 5 个字符
                echo mb_substr($row5["videoname"],0,6,'utf-8');
                ?></a>
              </p>
            </li>
            <?php
          }
          ?>
        </ul>
      </div>


      <div class="list-group text-center" id="sidebar">
        <h2 style="color:white;" >下载排行</h2>
        <ul class="list-inline row text-center">
          <?php
          while($row5=mysql_fetch_assoc($result6))
          {
            ?>
            <li class="col-xs-12 col-lg-6">
              <img src="./images/<?php
              echo $row5["pic"];
              ?>" class="responsive img-thumbnail" />
              239
              <p><a href="show.php?vid=<?php
                echo $row5["vid"];
                ?>"><?php
//显示视频名称中的前 5 个字符
                echo mb_substr($row5["videoname"],0,6,'utf-8');
                ?></a>
              </p>
            </li>
            <?php
          }
          ?>
        </ul>
      </div>    
    </div>    
  </div>
  <!--/row-->
</div>
<!--/.container-->
<hr>
<footer> 
  <p>&copy; Company 2014</p>
</footer> 

<!-- Bootstrap core JavaScript
  ================================================== -->
  <!-- Placed at the end of the document so the pages load faster -->
  <script src="assets/js/jquery.min.js"></script>
  <script src="assets/js/bootstrap.min.js"></script>

  <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
  <script src="assets/js/ie10-viewport-bug-workaround.js"></script>

  <script src="offcanvas.js"></script>
  <script>
    $('.carousel').carousel({
        interval: 3000 //changes the speed
      })
    </script>
  </body>
  </html>
